package com.sdkj.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sdkj.pojo.Checkitem;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CheckitemMapper  extends BaseMapper<Checkitem> {

    @Select("SELECT * FROM checkitem WHERE id IN(SELECT checkitem_id FROM checkgroupcheckitem WHERE checkgroup_id=#{gid})")
    public List<Checkitem> getItemByGid(@Param("gid") Integer gid);
}
